Dieser 5-tägige Kurs vermittelt Ihnen ein Verständnis der Transact-SQL-Sprache, die von allen SQL-Server-bezogenen Disziplinen genutzt wird: Datenbankadministration, Datenbankentwicklung und Business Intelligence.
Zielgruppe / Vorkenntnisse
Dieser Kurs richtet sich an:
Datenbankadministratoren
Datenbankentwickler
Business Intelligence Professionals
Praktische Kenntnisse von relationalen Datenbanken
Grundlegende Kenntnisse des Microsoft Windows-Betriebssystems und seinen Kernfunktionalitäten
Kursinhalt
Dieser Kurs behandelt die folgenden Themen:
The Basic Architecture of SQL Server
SQL Server Editions and Versions
Getting Started with SQL Server Management Studio
Introducing T-SQL
Understanding Sets
Understanding Predicate Logic
Understanding the Logical Order of Operations in SELECT statements
Writing Simple SELECT Statements
Eliminating Duplicates with DISTINCT
Using Column and Table Aliases
Writing Simple CASE Expressions
Understanding Joins
Querying with Inner Joins
Querying with Outer Joins
Querying with Cross Joins and Self Joins
Sorting Data
Filtering Data with Predicates
Filtering Data with TOP and OFFSET-FETCH
Working with Unknown Values
Introducing SQL Server 2016 Data Types
Working with Character Data
Working with Date and Time Data
Inserting Data
Modifying and Deleting Data
Writing Queries with Built-In Functions
Using Conversion Functions
Using Logical Functions
Using Functions to Work with NULL
Using Aggregate Functions
Using the GROUP BY Clause
Filtering Groups with HAVING
Writing Self-Contained Subqueries
Writing Correlated Subqueries
Using the EXISTS Predicate with Subqueries
Using Views
Using Inline Table-Valued Functions
Using Derived Tables
Using Common Table Expressions
Writing Queries with the UNION operator
Using EXCEPT and INTERSECT
Using APPLY
Creating Windows with OVER
Exploring Window Functions
Writing Queries with PIVOT and UNPIVOT
Working with Grouping Sets
Querying Data with Stored Procedures
Passing Parameters to Stored procedures
Creating Simple Stored Procedures
Working with Dynamic SQL
T-SQL Programming Elements
Controlling Program Flow
Implementing T-SQL error handling
Implementing structured exception handling
Transactions and the database engines
Controlling transactions
Schulungsdauer
Schulungsdauer
5 Tage
Schulungsart
Schulungsart
Kurs durch Trainer
Weitere Infos
Beginn: Am ersten Kurstag um 10.00 Uhr: Ca. 15 Minuten sind vor Kursbeginn für die Registrierung vorgesehen. An den nachfolgenden Tagen sind die Kurszeiten von 9.00 - 17.00 Uhr.